CREATE PROCEDURE LanguageGet
	@LanguageId int	
AS
SELECT *
FROM [Language]
WHERE [Language].[LanguageId] = @LanguageId
GO

CREATE PROCEDURE LanguageList
AS
SELECT *
FROM [Language]
GO

ALTER PROCEDURE LanguageInsert
	@LanguageName nvarchar(128)
AS

INSERT INTO [Language] (
	[LanguageName]
) VALUES (
	@LanguageName
)
select SCOPE_IDENTITY()
GO

CREATE PROCEDURE LanguageUpdate
	@LanguageId int, 
	@LanguageName nvarchar(128)
AS
UPDATE [Language] SET
	   [LanguageName] = @LanguageName
WHERE [Language].[LanguageId] = @LanguageId
GO

CREATE PROCEDURE LanguageDelete
	@LanguageId int
AS
DELETE FROM [Language]
WHERE [Language].[LanguageId] = @LanguageId
GO
